Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	1000
Missing cells	2078
Missing cells (%)	16.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	101.7 KiB
Average record size in memory	104.1 B

Variable types

Numeric	2
Categorical	11

Alerts

`countryCode` has constant value "GB"	Constant
`name` has a high cardinality: 993 distinct values	High cardinality
`foundingDate` has a high cardinality: 875 distinct values	High cardinality
`dissolutionDate` has a high cardinality: 132 distinct values	High cardinality
`companiesHouseID` has a high cardinality: 1000 distinct values	High cardinality
`openCorporatesID` has a high cardinality: 993 distinct values	High cardinality
`openOwnershipRegisterID` has a high cardinality: 1000 distinct values	High cardinality
`SICCode_SicText_1` has a high cardinality: 195 distinct values	High cardinality
`CompanyCategory` is highly correlated with `countryCode`	High correlation
`Accounts_AccountCategory` is highly correlated with `countryCode`	High correlation
`CompanyStatus` is highly correlated with `countryCode`	High correlation
`countryCode` is highly correlated with `CompanyCategory` and 2 other fields	High correlation
`dissolutionDate` has 749 (74.9%) missing values	Missing
`CompanyCategory` has 327 (32.7%) missing values	Missing
`CompanyStatus` has 327 (32.7%) missing values	Missing
`Accounts_AccountCategory` has 327 (32.7%) missing values	Missing
`SICCode_SicText_1` has 327 (32.7%) missing values	Missing
`name` is uniformly distributed	Uniform
`foundingDate` is uniformly distributed	Uniform
`companiesHouseID` is uniformly distributed	Uniform
`openCorporatesID` is uniformly distributed	Uniform
`openOwnershipRegisterID` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`statementID` has unique values	Unique
`companiesHouseID` has unique values	Unique
`openOwnershipRegisterID` has unique values	Unique

Reproduction

Analysis started	2022-06-01 21:23:51.293361
Analysis finished	2022-06-01 21:24:10.024138
Duration	18.73 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	1000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3657.32

Minimum	11
Maximum	7283
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	11
5-th percentile	400.8
Q1	1824
median	3634
Q3	5403.75
95-th percentile	6834.05
Maximum	7283
Range	7272
Interquartile range (IQR)	3579.75

Descriptive statistics

Standard deviation	2077.900089
Coefficient of variation (CV)	0.5681482858
Kurtosis	-1.203192438
Mean	3657.32
Median Absolute Deviation (MAD)	1786
Skewness	-0.01622520546
Sum	3657320
Variance	4317668.778
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2480	1	0.1%
3316	1	0.1%
6528	1	0.1%
6526	1	0.1%
1572	1	0.1%
2686	1	0.1%
2575	1	0.1%
1180	1	0.1%
2131	1	0.1%
3290	1	0.1%
Other values (990)	990	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	1	0.1%
17	1	0.1%
20	1	0.1%
27	1	0.1%
30	1	0.1%
41	1	0.1%
52	1	0.1%
56	1	0.1%
60	1	0.1%
69	1	0.1%

Value	Count	Frequency (%)
7283	1	0.1%
7273	1	0.1%
7267	1	0.1%
7265	1	0.1%
7242	1	0.1%
7240	1	0.1%
7234	1	0.1%
7227	1	0.1%
7219	1	0.1%
7217	1	0.1%

statementID
Real number (ℝ_≥0)

UNIQUE

Distinct	1000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.022696483 × 10¹⁸

Minimum	2.207652262 × 10¹⁶
Maximum	1.843110538 × 10¹⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.9 KiB

Quantile statistics

Minimum	2.207652262 × 10¹⁶
5-th percentile	8.793039468 × 10¹⁷
Q1	4.53594823 × 10¹⁸
median	8.68441055 × 10¹⁸
Q3	1.359725972 × 10¹⁹
95-th percentile	1.75766796 × 10¹⁹
Maximum	1.843110538 × 10¹⁹
Range	1.840902886 × 10¹⁹
Interquartile range (IQR)	9.061311494 × 10¹⁸

Descriptive statistics

Standard deviation	5.289407333 × 10¹⁸
Coefficient of variation (CV)	0.5862335436
Kurtosis	-1.178589278
Mean	9.022696483 × 10¹⁸
Median Absolute Deviation (MAD)	4.532392026 × 10¹⁸
Skewness	0.09522403697
Sum	9.022696483 × 10²¹
Variance	2.797782993 × 10³⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.009810236 × 10¹⁸	1	0.1%
5.22541436 × 10¹⁸	1	0.1%
1.14865743 × 10¹⁹	1	0.1%
1.115993323 × 10¹⁹	1	0.1%
1.373399064 × 10¹⁸	1	0.1%
6.657484594 × 10¹⁸	1	0.1%
1.320294528 × 10¹⁹	1	0.1%
1.211590486 × 10¹⁹	1	0.1%
1.376978863 × 10¹⁹	1	0.1%
1.26145512 × 10¹⁹	1	0.1%
Other values (990)	990	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.207652262 × 10¹⁶	1	0.1%
6.078762817 × 10¹⁶	1	0.1%
6.984294855 × 10¹⁶	1	0.1%
1.312573226 × 10¹⁷	1	0.1%
1.433841229 × 10¹⁷	1	0.1%
1.481273235 × 10¹⁷	1	0.1%
1.868366202 × 10¹⁷	1	0.1%
2.11249959 × 10¹⁷	1	0.1%
2.164221699 × 10¹⁷	1	0.1%
2.173754228 × 10¹⁷	1	0.1%

Value	Count	Frequency (%)
1.843110538 × 10¹⁹	1	0.1%
1.842974351 × 10¹⁹	1	0.1%
1.842214572 × 10¹⁹	1	0.1%
1.841969631 × 10¹⁹	1	0.1%
1.841285706 × 10¹⁹	1	0.1%
1.835112392 × 10¹⁹	1	0.1%
1.834968919 × 10¹⁹	1	0.1%
1.832073919 × 10¹⁹	1	0.1%
1.831679345 × 10¹⁹	1	0.1%
1.823792987 × 10¹⁹	1	0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	993
Distinct (%)	100.0%
Missing	7
Missing (%)	0.7%
Memory size	7.9 KiB

CIFRA SERVICES LTD	1
ARCHAX CAPITAL LTD	1
LOWER THE BAR LIMITED	1
TOKA EVENTS LTD	1
OPTIMISTIC INFLUENCE LTD	1
Other values (988)	988

Length

Max length	72
Median length	44
Mean length	23.28096677
Min length	8

Characters and Unicode

Total characters	23118
Distinct characters	49
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	993 ?
Unique (%)	100.0%

Sample

1st row	CIFRA SERVICES LTD
2nd row	BRADFORD ONLINE LIMITED
3rd row	FIRE PROTECTION PRODUCTS LIMITED
4th row	ALLSITE CATERING LIMITED
5th row	KNOWLES SYSTEMS LIMITED

Common Values

Value	Count	Frequency (%)
CIFRA SERVICES LTD	1	0.1%
ARCHAX CAPITAL LTD	1	0.1%
LOWER THE BAR LIMITED	1	0.1%
TOKA EVENTS LTD	1	0.1%
OPTIMISTIC INFLUENCE LTD	1	0.1%
WANDERLUST CLUB LIMITED	1	0.1%
GOOD NUTS LTD	1	0.1%
SWAN COMMERCIAL PROPERTIES LIMITED	1	0.1%
MANOR GARDENS (HOLSWORTHY) MANAGEMENT COMPANY LIMITED	1	0.1%
CHAKIB RICHANI COLLECTION LTD	1	0.1%
Other values (983)	983	98.3%
(Missing)	7	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
limited	513	14.8%
ltd	449	13.0%
services	55	1.6%
	50	1.4%
the	34	1.0%
uk	31	0.9%
company	25	0.7%
and	22	0.6%
property	22	0.6%
solutions	22	0.6%
Other values (1657)	2240	64.7%

Most occurring characters

Value	Count	Frequency (%)
	2470	10.7%
I	2139	9.3%
E	2109	9.1%
T	2058	8.9%
L	1739	7.5%
D	1398	6.0%
A	1237	5.4%
S	1204	5.2%
R	1173	5.1%
N	1168	5.1%
Other values (39)	6423	27.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	20305	87.8%
Space Separator	2470	10.7%
Other Punctuation	129	0.6%
Decimal Number	103	0.4%
Open Punctuation	50	0.2%
Close Punctuation	50	0.2%
Dash Punctuation	10	< 0.1%
Final Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	2139	10.5%
E	2109	10.4%
T	2058	10.1%
L	1739	8.6%
D	1398	6.9%
A	1237	6.1%
S	1204	5.9%
R	1173	5.8%
N	1168	5.8%
O	1102	5.4%
Other values (18)	4978	24.5%

Decimal Number

Value	Count	Frequency (%)
1	26	25.2%
2	17	16.5%
4	12	11.7%
7	10	9.7%
0	10	9.7%
9	8	7.8%
5	8	7.8%
3	6	5.8%
8	3	2.9%
6	3	2.9%

Other Punctuation

Value	Count	Frequency (%)
.	62	48.1%
&	56	43.4%
'	8	6.2%
@	1	0.8%
,	1	0.8%
/	1	0.8%

Space Separator

Value	Count	Frequency (%)
	2470	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	50	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	50	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20305	87.8%
Common	2813	12.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	2139	10.5%
E	2109	10.4%
T	2058	10.1%
L	1739	8.6%
D	1398	6.9%
A	1237	6.1%
S	1204	5.9%
R	1173	5.8%
N	1168	5.8%
O	1102	5.4%
Other values (18)	4978	24.5%

Common

Value	Count	Frequency (%)
	2470	87.8%
.	62	2.2%
&	56	2.0%
(	50	1.8%
)	50	1.8%
1	26	0.9%
2	17	0.6%
4	12	0.4%
7	10	0.4%
0	10	0.4%
Other values (11)	50	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23115	> 99.9%
None	2	< 0.1%
Punctuation	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2470	10.7%
I	2139	9.3%
E	2109	9.1%
T	2058	8.9%
L	1739	7.5%
D	1398	6.0%
A	1237	5.4%
S	1204	5.2%
R	1173	5.1%
N	1168	5.1%
Other values (36)	6420	27.8%

None

Value	Count	Frequency (%)
É	1	50.0%
È	1	50.0%

Punctuation

Value	Count	Frequency (%)
’	1	100.0%

foundingDate
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	875
Distinct (%)	88.1%
Missing	7
Missing (%)	0.7%
Memory size	7.9 KiB

2019-08-09	3
2012-09-25	3
2021-08-06	3
2021-04-26	3
2018-04-05	3
Other values (870)	978

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	9930
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	769 ?
Unique (%)	77.4%

Sample

1st row	2021-04-21
2nd row	2018-11-12
3rd row	2004-08-10
4th row	2017-11-14
5th row	2007-02-12

Common Values

Value	Count	Frequency (%)
2019-08-09	3	0.3%
2012-09-25	3	0.3%
2021-08-06	3	0.3%
2021-04-26	3	0.3%
2018-04-05	3	0.3%
2019-06-17	3	0.3%
2016-07-15	3	0.3%
2014-07-03	3	0.3%
2019-03-23	3	0.3%
2018-09-26	3	0.3%
Other values (865)	963	96.3%
(Missing)	7	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2019-08-09	3	0.3%
2014-07-03	3	0.3%
2012-09-25	3	0.3%
2018-10-03	3	0.3%
2018-09-26	3	0.3%
2019-03-23	3	0.3%
2022-02-24	3	0.3%
2016-07-15	3	0.3%
2019-06-17	3	0.3%
2018-04-05	3	0.3%
Other values (865)	963	97.0%

Most occurring characters

Value	Count	Frequency (%)
0	2440	24.6%
-	1986	20.0%
2	1828	18.4%
1	1583	15.9%
9	393	4.0%
8	311	3.1%
6	298	3.0%
5	292	2.9%
7	283	2.8%
3	282	2.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7944	80.0%
Dash Punctuation	1986	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2440	30.7%
2	1828	23.0%
1	1583	19.9%
9	393	4.9%
8	311	3.9%
6	298	3.8%
5	292	3.7%
7	283	3.6%
3	282	3.5%
4	234	2.9%

Dash Punctuation

Value	Count	Frequency (%)
-	1986	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	9930	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2440	24.6%
-	1986	20.0%
2	1828	18.4%
1	1583	15.9%
9	393	4.0%
8	311	3.1%
6	298	3.0%
5	292	2.9%
7	283	2.8%
3	282	2.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9930	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2440	24.6%
-	1986	20.0%
2	1828	18.4%
1	1583	15.9%
9	393	4.0%
8	311	3.1%
6	298	3.0%
5	292	2.9%
7	283	2.8%
3	282	2.8%

dissolutionDate
Categorical

HIGH CARDINALITY
MISSING

Distinct	132
Distinct (%)	52.6%
Missing	749
Missing (%)	74.9%
Memory size	7.9 KiB

2020-10-13	8
2018-01-02	6
2021-03-23	6
2020-03-17	6
2021-03-16	4
Other values (127)	221

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2510
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	70 ?
Unique (%)	27.9%

Sample

1st row	2020-10-20
2nd row	2019-04-23
3rd row	2021-04-06
4th row	2021-05-25
5th row	2018-03-20

Common Values

Value	Count	Frequency (%)
2020-10-13	8	0.8%
2018-01-02	6	0.6%
2021-03-23	6	0.6%
2020-03-17	6	0.6%
2021-03-16	4	0.4%
2021-01-26	4	0.4%
2020-02-04	4	0.4%
2020-10-20	4	0.4%
2020-12-22	4	0.4%
2021-06-22	4	0.4%
Other values (122)	201	20.1%
(Missing)	749	74.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-10-13	8	3.2%
2021-03-23	6	2.4%
2020-03-17	6	2.4%
2018-01-02	6	2.4%
2020-12-22	4	1.6%
2017-12-19	4	1.6%
2021-06-22	4	1.6%
2018-02-27	4	1.6%
2020-10-20	4	1.6%
2020-02-04	4	1.6%
Other values (122)	201	80.1%

Most occurring characters

Value	Count	Frequency (%)
0	611	24.3%
2	526	21.0%
-	502	20.0%
1	426	17.0%
9	98	3.9%
8	96	3.8%
3	75	3.0%
7	64	2.5%
6	45	1.8%
4	39	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2008	80.0%
Dash Punctuation	502	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	611	30.4%
2	526	26.2%
1	426	21.2%
9	98	4.9%
8	96	4.8%
3	75	3.7%
7	64	3.2%
6	45	2.2%
4	39	1.9%
5	28	1.4%

Dash Punctuation

Value	Count	Frequency (%)
-	502	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2510	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	611	24.3%
2	526	21.0%
-	502	20.0%
1	426	17.0%
9	98	3.9%
8	96	3.8%
3	75	3.0%
7	64	2.5%
6	45	1.8%
4	39	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2510	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	611	24.3%
2	526	21.0%
-	502	20.0%
1	426	17.0%
9	98	3.9%
8	96	3.8%
3	75	3.0%
7	64	2.5%
6	45	1.8%
4	39	1.6%

countryCode
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

GB	1000

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2000
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GB
2nd row	GB
3rd row	GB
4th row	GB
5th row	GB

Common Values

Value	Count	Frequency (%)
GB	1000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
gb	1000	100.0%

Most occurring characters

Value	Count	Frequency (%)
G	1000	50.0%
B	1000	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2000	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	1000	50.0%
B	1000	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2000	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	1000	50.0%
B	1000	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	1000	50.0%
B	1000	50.0%

companiesHouseID
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	1000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

13348512	1
06379523	1
11806852	1
11288817	1
13657977	1
Other values (995)	995

Length

Max length	8
Median length	8
Mean length	7.999
Min length	7

Characters and Unicode

Total characters	7999
Distinct characters	16
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1000 ?
Unique (%)	100.0%

Sample

1st row	13348512
2nd row	11673158
3rd row	NI051395
4th row	11062947
5th row	06094377

Common Values

Value	Count	Frequency (%)
13348512	1	0.1%
06379523	1	0.1%
11806852	1	0.1%
11288817	1	0.1%
13657977	1	0.1%
12296905	1	0.1%
11558755	1	0.1%
11243377	1	0.1%
06369590	1	0.1%
10353571	1	0.1%
Other values (990)	990	99.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
13348512	1	0.1%
03025737	1	0.1%
08304199	1	0.1%
13170064	1	0.1%
ni051395	1	0.1%
11062947	1	0.1%
06094377	1	0.1%
12224782	1	0.1%
oc402894	1	0.1%
12674178	1	0.1%
Other values (990)	990	99.0%

Most occurring characters

Value	Count	Frequency (%)
1	1285	16.1%
0	1101	13.8%
2	742	9.3%
9	742	9.3%
3	736	9.2%
7	691	8.6%
5	665	8.3%
8	657	8.2%
6	618	7.7%
4	602	7.5%
Other values (6)	160	2.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	7839	98.0%
Uppercase Letter	160	2.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1285	16.4%
0	1101	14.0%
2	742	9.5%
9	742	9.5%
3	736	9.4%
7	691	8.8%
5	665	8.5%
8	657	8.4%
6	618	7.9%
4	602	7.7%

Uppercase Letter

Value	Count	Frequency (%)
C	70	43.8%
S	63	39.4%
O	13	8.1%
N	6	3.8%
I	6	3.8%
L	2	1.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	7839	98.0%
Latin	160	2.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1285	16.4%
0	1101	14.0%
2	742	9.5%
9	742	9.5%
3	736	9.4%
7	691	8.8%
5	665	8.5%
8	657	8.4%
6	618	7.9%
4	602	7.7%

Latin

Value	Count	Frequency (%)
C	70	43.8%
S	63	39.4%
O	13	8.1%
N	6	3.8%
I	6	3.8%
L	2	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7999	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1285	16.1%
0	1101	13.8%
2	742	9.3%
9	742	9.3%
3	736	9.2%
7	691	8.6%
5	665	8.3%
8	657	8.2%
6	618	7.7%
4	602	7.5%
Other values (6)	160	2.0%

openCorporatesID
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	993
Distinct (%)	100.0%
Missing	7
Missing (%)	0.7%
Memory size	7.9 KiB

https://opencorporates.com/companies/gb/13348512	1
https://opencorporates.com/companies/gb/11477975	1
https://opencorporates.com/companies/gb/11288817	1
https://opencorporates.com/companies/gb/13657977	1
https://opencorporates.com/companies/gb/12296905	1
Other values (988)	988

Length

Max length	48
Median length	48
Mean length	48
Min length	48

Characters and Unicode

Total characters	47664
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	993 ?
Unique (%)	100.0%

Sample

1st row	https://opencorporates.com/companies/gb/13348512
2nd row	https://opencorporates.com/companies/gb/11673158
3rd row	https://opencorporates.com/companies/gb/NI051395
4th row	https://opencorporates.com/companies/gb/11062947
5th row	https://opencorporates.com/companies/gb/06094377

Common Values

Value	Count	Frequency (%)
https://opencorporates.com/companies/gb/13348512	1	0.1%
https://opencorporates.com/companies/gb/11477975	1	0.1%
https://opencorporates.com/companies/gb/11288817	1	0.1%
https://opencorporates.com/companies/gb/13657977	1	0.1%
https://opencorporates.com/companies/gb/12296905	1	0.1%
https://opencorporates.com/companies/gb/11558755	1	0.1%
https://opencorporates.com/companies/gb/11243377	1	0.1%
https://opencorporates.com/companies/gb/06369590	1	0.1%
https://opencorporates.com/companies/gb/10353571	1	0.1%
https://opencorporates.com/companies/gb/07412667	1	0.1%
Other values (983)	983	98.3%
(Missing)	7	0.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://opencorporates.com/companies/gb/13348512	1	0.1%
https://opencorporates.com/companies/gb/03767880	1	0.1%
https://opencorporates.com/companies/gb/13170064	1	0.1%
https://opencorporates.com/companies/gb/ni051395	1	0.1%
https://opencorporates.com/companies/gb/11062947	1	0.1%
https://opencorporates.com/companies/gb/06094377	1	0.1%
https://opencorporates.com/companies/gb/12224782	1	0.1%
https://opencorporates.com/companies/gb/oc402894	1	0.1%
https://opencorporates.com/companies/gb/12674178	1	0.1%
https://opencorporates.com/companies/gb/08447018	1	0.1%
Other values (983)	983	99.0%

Most occurring characters

Value	Count	Frequency (%)
/	4965	10.4%
o	4965	10.4%
p	3972	8.3%
s	2979	6.2%
e	2979	6.2%
c	2979	6.2%
t	2979	6.2%
n	1986	4.2%
r	1986	4.2%
a	1986	4.2%
Other values (23)	15888	33.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	32769	68.8%
Decimal Number	7784	16.3%
Other Punctuation	6951	14.6%
Uppercase Letter	160	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	4965	15.2%
p	3972	12.1%
s	2979	9.1%
e	2979	9.1%
c	2979	9.1%
t	2979	9.1%
n	1986	6.1%
r	1986	6.1%
a	1986	6.1%
m	1986	6.1%
Other values (4)	3972	12.1%

Decimal Number

Value	Count	Frequency (%)
1	1273	16.4%
0	1100	14.1%
9	739	9.5%
2	738	9.5%
3	725	9.3%
7	687	8.8%
8	654	8.4%
5	654	8.4%
6	616	7.9%
4	598	7.7%

Uppercase Letter

Value	Count	Frequency (%)
C	70	43.8%
S	63	39.4%
O	13	8.1%
N	6	3.8%
I	6	3.8%
L	2	1.2%

Other Punctuation

Value	Count	Frequency (%)
/	4965	71.4%
.	993	14.3%
:	993	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	32929	69.1%
Common	14735	30.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	4965	15.1%
p	3972	12.1%
s	2979	9.0%
e	2979	9.0%
c	2979	9.0%
t	2979	9.0%
n	1986	6.0%
r	1986	6.0%
a	1986	6.0%
m	1986	6.0%
Other values (10)	4132	12.5%

Common

Value	Count	Frequency (%)
/	4965	33.7%
1	1273	8.6%
0	1100	7.5%
.	993	6.7%
:	993	6.7%
9	739	5.0%
2	738	5.0%
3	725	4.9%
7	687	4.7%
8	654	4.4%
Other values (3)	1868	12.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	47664	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	4965	10.4%
o	4965	10.4%
p	3972	8.3%
s	2979	6.2%
e	2979	6.2%
c	2979	6.2%
t	2979	6.2%
n	1986	4.2%
r	1986	4.2%
a	1986	4.2%
Other values (23)	15888	33.3%

openOwnershipRegisterID
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	1000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	7.9 KiB

http://register.openownership.org/entities/60999516e4e645384b151f9f	1
http://register.openownership.org/entities/59b944a967e4ebf3408c185d	1
http://register.openownership.org/entities/5c5bdddd9dfc3fae182d2bf7	1
http://register.openownership.org/entities/5b166c5a9dfc3fae185f7481	1
http://register.openownership.org/entities/6169714a5a8495d725b5f0d6	1
Other values (995)	995

Length

Max length	67
Median length	67
Mean length	67
Min length	67

Characters and Unicode

Total characters	67000
Distinct characters	29
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1000 ?
Unique (%)	100.0%

Sample

1st row	http://register.openownership.org/entities/60999516e4e645384b151f9f
2nd row	http://register.openownership.org/entities/5bf44c979dfc3fae18c57ab0
3rd row	http://register.openownership.org/entities/59b93d3767e4ebf3406ca5bb
4th row	http://register.openownership.org/entities/5aba261d9dfc3fae1894f164
5th row	http://register.openownership.org/entities/59c500f167e4ebf3405d9caa

Common Values

Value	Count	Frequency (%)
http://register.openownership.org/entities/60999516e4e645384b151f9f	1	0.1%
http://register.openownership.org/entities/59b944a967e4ebf3408c185d	1	0.1%
http://register.openownership.org/entities/5c5bdddd9dfc3fae182d2bf7	1	0.1%
http://register.openownership.org/entities/5b166c5a9dfc3fae185f7481	1	0.1%
http://register.openownership.org/entities/6169714a5a8495d725b5f0d6	1	0.1%
http://register.openownership.org/entities/5dc2c4149dfc3fae18cbd17c	1	0.1%
http://register.openownership.org/entities/5bbb801a9dfc3fae18511b6b	1	0.1%
http://register.openownership.org/entities/5ab97d849dfc3fae18ee06c4	1	0.1%
http://register.openownership.org/entities/59b942d767e4ebf34085154d	1	0.1%
http://register.openownership.org/entities/59b936ac67e4ebf3404e8d37	1	0.1%
Other values (990)	990	99.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
http://register.openownership.org/entities/60999516e4e645384b151f9f	1	0.1%
http://register.openownership.org/entities/59b9b73e67e4ebf34078b91b	1	0.1%
http://register.openownership.org/entities/59b9622e67e4ebf34014d5b5	1	0.1%
http://register.openownership.org/entities/604ba888fcb54a9955eb134d	1	0.1%
http://register.openownership.org/entities/59b93d3767e4ebf3406ca5bb	1	0.1%
http://register.openownership.org/entities/5aba261d9dfc3fae1894f164	1	0.1%
http://register.openownership.org/entities/59c500f167e4ebf3405d9caa	1	0.1%
http://register.openownership.org/entities/5d8b7ca89dfc3fae180350e5	1	0.1%
http://register.openownership.org/entities/59b9635567e4ebf3401aad9b	1	0.1%
http://register.openownership.org/entities/5f1f11ec84281976229cd306	1	0.1%
Other values (990)	990	99.0%

Most occurring characters

Value	Count	Frequency (%)
e	8082	12.1%
t	5000	7.5%
i	4000	6.0%
/	4000	6.0%
r	4000	6.0%
s	3000	4.5%
p	3000	4.5%
n	3000	4.5%
o	3000	4.5%
9	2156	3.2%
Other values (19)	27762	41.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45340	67.7%
Decimal Number	14660	21.9%
Other Punctuation	7000	10.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	8082	17.8%
t	5000	11.0%
i	4000	8.8%
r	4000	8.8%
s	3000	6.6%
p	3000	6.6%
n	3000	6.6%
o	3000	6.6%
b	2063	4.6%
g	2000	4.4%
Other values (6)	8195	18.1%

Decimal Number

Value	Count	Frequency (%)
9	2156	14.7%
4	2070	14.1%
5	1715	11.7%
6	1545	10.5%
3	1526	10.4%
7	1389	9.5%
0	1338	9.1%
1	1050	7.2%
8	990	6.8%
2	881	6.0%

Other Punctuation

Value	Count	Frequency (%)
/	4000	57.1%
.	2000	28.6%
:	1000	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	45340	67.7%
Common	21660	32.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	8082	17.8%
t	5000	11.0%
i	4000	8.8%
r	4000	8.8%
s	3000	6.6%
p	3000	6.6%
n	3000	6.6%
o	3000	6.6%
b	2063	4.6%
g	2000	4.4%
Other values (6)	8195	18.1%

Common

Value	Count	Frequency (%)
/	4000	18.5%
9	2156	10.0%
4	2070	9.6%
.	2000	9.2%
5	1715	7.9%
6	1545	7.1%
3	1526	7.0%
7	1389	6.4%
0	1338	6.2%
1	1050	4.8%
Other values (3)	2871	13.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	67000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	8082	12.1%
t	5000	7.5%
i	4000	6.0%
/	4000	6.0%
r	4000	6.0%
s	3000	4.5%
p	3000	4.5%
n	3000	4.5%
o	3000	4.5%
9	2156	3.2%
Other values (19)	27762	41.4%

CompanyCategory
Categorical

HIGH CORRELATION
MISSING

Distinct	7
Distinct (%)	1.0%
Missing	327
Missing (%)	32.7%
Memory size	7.9 KiB

Private Limited Company	630
PRI/LTD BY GUAR/NSC (Private, limited by guarantee, no share capital)	24
Limited Liability Partnership	8
PRI/LBG/NSC (Private, Limited by guarantee, no share capital, use of 'Limited' exemption)	4
Community Interest Company	4
Other values (2)	3

Length

Max length	89
Median length	23
Mean length	25.11292719
Min length	19

Characters and Unicode

Total characters	16901
Distinct characters	41
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	Private Limited Company
2nd row	Private Limited Company
3rd row	Private Limited Company
4th row	Limited Liability Partnership
5th row	Private Limited Company

Common Values

Value	Count	Frequency (%)
Private Limited Company	630	63.0%
PRI/LTD BY GUAR/NSC (Private, limited by guarantee, no share capital)	24	2.4%
Limited Liability Partnership	8	0.8%
PRI/LBG/NSC (Private, Limited by guarantee, no share capital, use of 'Limited' exemption)	4	0.4%
Community Interest Company	4	0.4%
Limited Partnership	2	0.2%
Private Unlimited Company	1	0.1%
(Missing)	327	32.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
limited	672	30.3%
private	659	29.7%
company	635	28.6%
by	52	2.3%
no	28	1.3%
share	28	1.3%
capital	28	1.3%
guarantee	28	1.3%
guar/nsc	24	1.1%
pri/ltd	24	1.1%
Other values (9)	43	1.9%

Most occurring characters

Value	Count	Frequency (%)
i	2075	12.3%
	1548	9.2%
a	1452	8.6%
e	1446	8.6%
t	1422	8.4%
m	1320	7.8%
r	739	4.4%
n	714	4.2%
P	697	4.1%
L	684	4.0%
Other values (31)	4804	28.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12808	75.8%
Uppercase Letter	2365	14.0%
Space Separator	1548	9.2%
Other Punctuation	124	0.7%
Open Punctuation	28	0.2%
Close Punctuation	28	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	2075	16.2%
a	1452	11.3%
e	1446	11.3%
t	1422	11.1%
m	1320	10.3%
r	739	5.8%
n	714	5.6%
p	677	5.3%
y	675	5.3%
o	675	5.3%
Other values (11)	1613	12.6%

Uppercase Letter

Value	Count	Frequency (%)
P	697	29.5%
L	684	28.9%
C	667	28.2%
R	52	2.2%
I	32	1.4%
G	28	1.2%
N	28	1.2%
S	28	1.2%
B	28	1.2%
U	25	1.1%
Other values (4)	96	4.1%

Other Punctuation

Value	Count	Frequency (%)
,	60	48.4%
/	56	45.2%
'	8	6.5%

Space Separator

Value	Count	Frequency (%)
	1548	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	28	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	28	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15173	89.8%
Common	1728	10.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	2075	13.7%
a	1452	9.6%
e	1446	9.5%
t	1422	9.4%
m	1320	8.7%
r	739	4.9%
n	714	4.7%
P	697	4.6%
L	684	4.5%
p	677	4.5%
Other values (25)	3947	26.0%

Common

Value	Count	Frequency (%)
	1548	89.6%
,	60	3.5%
/	56	3.2%
(	28	1.6%
)	28	1.6%
'	8	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16901	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	2075	12.3%
	1548	9.2%
a	1452	8.6%
e	1446	8.6%
t	1422	8.4%
m	1320	7.8%
r	739	4.4%
n	714	4.2%
P	697	4.1%
L	684	4.0%
Other values (31)	4804	28.4%

CompanyStatus
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.4%
Missing	327
Missing (%)	32.7%
Memory size	7.9 KiB

Active	639
Active - Proposal to Strike off	29
Liquidation	5

Length

Max length	31
Median length	6
Mean length	7.114413076
Min length	6

Characters and Unicode

Total characters	4788
Distinct characters	23
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Active
2nd row	Active
3rd row	Active
4th row	Active - Proposal to Strike off
5th row	Active

Common Values

Value	Count	Frequency (%)
Active	639	63.9%
Active - Proposal to Strike off	29	2.9%
Liquidation	5	0.5%
(Missing)	327	32.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
active	668	81.7%
	29	3.5%
proposal	29	3.5%
to	29	3.5%
strike	29	3.5%
off	29	3.5%
liquidation	5	0.6%

Most occurring characters

Value	Count	Frequency (%)
t	731	15.3%
i	712	14.9%
e	697	14.6%
A	668	14.0%
v	668	14.0%
c	668	14.0%
	145	3.0%
o	121	2.5%
f	58	1.2%
r	58	1.2%
Other values (13)	262	5.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3883	81.1%
Uppercase Letter	731	15.3%
Space Separator	145	3.0%
Dash Punctuation	29	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	731	18.8%
i	712	18.3%
e	697	18.0%
v	668	17.2%
c	668	17.2%
o	121	3.1%
f	58	1.5%
r	58	1.5%
a	34	0.9%
l	29	0.7%
Other values (7)	107	2.8%

Uppercase Letter

Value	Count	Frequency (%)
A	668	91.4%
S	29	4.0%
P	29	4.0%
L	5	0.7%

Space Separator

Value	Count	Frequency (%)
	145	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4614	96.4%
Common	174	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	731	15.8%
i	712	15.4%
e	697	15.1%
A	668	14.5%
v	668	14.5%
c	668	14.5%
o	121	2.6%
f	58	1.3%
r	58	1.3%
a	34	0.7%
Other values (11)	199	4.3%

Common

Value	Count	Frequency (%)
	145	83.3%
-	29	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4788	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	731	15.3%
i	712	14.9%
e	697	14.6%
A	668	14.0%
v	668	14.0%
c	668	14.0%
	145	3.0%
o	121	2.5%
f	58	1.2%
r	58	1.2%
Other values (13)	262	5.5%

Accounts_AccountCategory
Categorical

HIGH CORRELATION
MISSING

Distinct	10
Distinct (%)	1.5%
Missing	327
Missing (%)	32.7%
Memory size	7.9 KiB

MICRO ENTITY	205
TOTAL EXEMPTION FULL	175
NO ACCOUNTS FILED	168
DORMANT	77
UNAUDITED ABRIDGED	22
Other values (5)	26

Length

Max length	21
Median length	20
Mean length	14.70430906
Min length	4

Characters and Unicode

Total characters	9896
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.3%

Sample

1st row	NO ACCOUNTS FILED
2nd row	MICRO ENTITY
3rd row	MICRO ENTITY
4th row	TOTAL EXEMPTION FULL
5th row	MICRO ENTITY

Common Values

Value	Count	Frequency (%)
MICRO ENTITY	205	20.5%
TOTAL EXEMPTION FULL	175	17.5%
NO ACCOUNTS FILED	168	16.8%
DORMANT	77	7.7%
UNAUDITED ABRIDGED	22	2.2%
FULL	12	1.2%
SMALL	8	0.8%
GROUP	4	0.4%
TOTAL EXEMPTION SMALL	1	0.1%
AUDITED ABRIDGED	1	0.1%
(Missing)	327	32.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
micro	205	12.9%
entity	205	12.9%
full	187	11.8%
total	176	11.1%
exemption	176	11.1%
no	168	10.6%
accounts	168	10.6%
filed	168	10.6%
dormant	77	4.8%
abridged	23	1.4%
Other values (4)	36	2.3%

Most occurring characters

Value	Count	Frequency (%)
T	1206	12.2%
O	974	9.8%
	916	9.3%
N	816	8.2%
I	800	8.1%
E	771	7.8%
L	736	7.4%
C	541	5.5%
A	476	4.8%
M	467	4.7%
Other values (10)	2193	22.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8980	90.7%
Space Separator	916	9.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	1206	13.4%
O	974	10.8%
N	816	9.1%
I	800	8.9%
E	771	8.6%
L	736	8.2%
C	541	6.0%
A	476	5.3%
M	467	5.2%
U	404	4.5%
Other values (9)	1789	19.9%

Space Separator

Value	Count	Frequency (%)
	916	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8980	90.7%
Common	916	9.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	1206	13.4%
O	974	10.8%
N	816	9.1%
I	800	8.9%
E	771	8.6%
L	736	8.2%
C	541	6.0%
A	476	5.3%
M	467	5.2%
U	404	4.5%
Other values (9)	1789	19.9%

Common

Value	Count	Frequency (%)
	916	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9896	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	1206	12.2%
O	974	9.8%
	916	9.3%
N	816	8.2%
I	800	8.1%
E	771	7.8%
L	736	7.4%
C	541	5.5%
A	476	4.8%
M	467	4.7%
Other values (10)	2193	22.2%

SICCode_SicText_1
Categorical

HIGH CARDINALITY
MISSING

Distinct	195
Distinct (%)	29.0%
Missing	327
Missing (%)	32.7%
Memory size	7.9 KiB

82990 - Other business support service activities n.e.c.	50
68209 - Other letting and operating of own or leased real estate	28
70229 - Management consultancy activities other than financial management	24
68100 - Buying and selling of own real estate	19
96090 - Other service activities n.e.c.	17
Other values (190)	535

Length

Max length	107
Median length	74
Mean length	48.10698366
Min length	13

Characters and Unicode

Total characters	32376
Distinct characters	66
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	96 ?
Unique (%)	14.3%

Sample

1st row	96090 - Other service activities n.e.c.
2nd row	43999 - Other specialised construction activities n.e.c.
3rd row	82990 - Other business support service activities n.e.c.
4th row	None Supplied
5th row	64209 - Activities of other holding companies n.e.c.

Common Values

Value	Count	Frequency (%)
82990 - Other business support service activities n.e.c.	50	5.0%
68209 - Other letting and operating of own or leased real estate	28	2.8%
70229 - Management consultancy activities other than financial management	24	2.4%
68100 - Buying and selling of own real estate	19	1.9%
96090 - Other service activities n.e.c.	17	1.7%
47910 - Retail sale via mail order houses or via Internet	17	1.7%
99999 - Dormant Company	17	1.7%
41100 - Development of building projects	15	1.5%
86900 - Other human health activities	13	1.3%
43999 - Other specialised construction activities n.e.c.	13	1.3%
Other values (185)	460	46.0%
(Missing)	327	32.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	663	13.4%
other	272	5.5%
activities	267	5.4%
of	200	4.1%
and	197	4.0%
n.e.c	114	2.3%
service	80	1.6%
management	76	1.5%
or	67	1.4%
sale	66	1.3%
Other values (578)	2931	59.4%

Most occurring characters

Value	Count	Frequency (%)
	4260	13.2%
e	2828	8.7%
i	2423	7.5%
t	2292	7.1%
a	1984	6.1%
n	1941	6.0%
s	1706	5.3%
o	1480	4.6%
r	1409	4.4%
c	1232	3.8%
Other values (56)	10821	33.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22958	70.9%
Space Separator	4260	13.2%
Decimal Number	3315	10.2%
Uppercase Letter	716	2.2%
Dash Punctuation	706	2.2%
Other Punctuation	417	1.3%
Close Punctuation	2	< 0.1%
Open Punctuation	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2828	12.3%
i	2423	10.6%
t	2292	10.0%
a	1984	8.6%
n	1941	8.5%
s	1706	7.4%
o	1480	6.4%
r	1409	6.1%
c	1232	5.4%
l	996	4.3%
Other values (16)	4667	20.3%

Uppercase Letter

Value	Count	Frequency (%)
O	216	30.2%
R	68	9.5%
M	62	8.7%
C	44	6.1%
A	38	5.3%
D	37	5.2%
S	36	5.0%
B	31	4.3%
F	28	3.9%
I	27	3.8%
Other values (12)	129	18.0%

Decimal Number

Value	Count	Frequency (%)
0	791	23.9%
9	614	18.5%
2	437	13.2%
1	346	10.4%
4	265	8.0%
6	234	7.1%
8	215	6.5%
7	164	4.9%
3	148	4.5%
5	101	3.0%

Other Punctuation

Value	Count	Frequency (%)
.	343	82.3%
,	72	17.3%
;	1	0.2%
'	1	0.2%

Space Separator

Value	Count	Frequency (%)
	4260	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	706	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	23674	73.1%
Common	8702	26.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2828	11.9%
i	2423	10.2%
t	2292	9.7%
a	1984	8.4%
n	1941	8.2%
s	1706	7.2%
o	1480	6.3%
r	1409	6.0%
c	1232	5.2%
l	996	4.2%
Other values (38)	5383	22.7%

Common

Value	Count	Frequency (%)
	4260	49.0%
0	791	9.1%
-	706	8.1%
9	614	7.1%
2	437	5.0%
1	346	4.0%
.	343	3.9%
4	265	3.0%
6	234	2.7%
8	215	2.5%
Other values (8)	491	5.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32376	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4260	13.2%
e	2828	8.7%
i	2423	7.5%
t	2292	7.1%
a	1984	6.1%
n	1941	6.0%
s	1706	5.3%
o	1480	4.6%
r	1409	4.4%
c	1232	3.8%
Other values (56)	10821	33.4%

df_index
statementID

statementID
df_index

statementID
df_index

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	statementID	name	foundingDate	dissolutionDate	countryCode	companiesHouseID	openCorporatesID	openOwnershipRegisterID	CompanyCategory	CompanyStatus	Accounts_AccountCategory	SICCode_SicText_1
0	2480	3009810236444562249	CIFRA SERVICES LTD	2021-04-21	None	GB	13348512	https://opencorporates.com/companies/gb/13348512	http://register.openownership.org/entities/60999516e4e645384b151f9f	Private Limited Company	Active	NO ACCOUNTS FILED	96090 - Other service activities n.e.c.
1	5246	11031123992823807139	BRADFORD ONLINE LIMITED	2018-11-12	2020-10-20	GB	11673158	https://opencorporates.com/companies/gb/11673158	http://register.openownership.org/entities/5bf44c979dfc3fae18c57ab0	None	None	None	None
2	5230	16034895648864300689	FIRE PROTECTION PRODUCTS LIMITED	2004-08-10	None	GB	NI051395	https://opencorporates.com/companies/gb/NI051395	http://register.openownership.org/entities/59b93d3767e4ebf3406ca5bb	Private Limited Company	Active	MICRO ENTITY	43999 - Other specialised construction activities n.e.c.
3	6078	13605112502038953621	ALLSITE CATERING LIMITED	2017-11-14	2019-04-23	GB	11062947	https://opencorporates.com/companies/gb/11062947	http://register.openownership.org/entities/5aba261d9dfc3fae1894f164	None	None	None	None
4	6307	5333408146780574678	KNOWLES SYSTEMS LIMITED	2007-02-12	None	GB	06094377	https://opencorporates.com/companies/gb/06094377	http://register.openownership.org/entities/59c500f167e4ebf3405d9caa	Private Limited Company	Active	MICRO ENTITY	82990 - Other business support service activities n.e.c.
5	3737	15458955880793802661	TRADE PLUS INVESTMENT LTD	2019-09-24	2021-04-06	GB	12224782	https://opencorporates.com/companies/gb/12224782	http://register.openownership.org/entities/5d8b7ca89dfc3fae180350e5	None	None	None	None
6	3052	5664068093023364540	MV MIRJAM LLP	2015-11-16	None	GB	OC402894	https://opencorporates.com/companies/gb/OC402894	http://register.openownership.org/entities/59b9635567e4ebf3401aad9b	Limited Liability Partnership	Active - Proposal to Strike off	TOTAL EXEMPTION FULL	None Supplied
7	27	16024097053705099358	LOMAX LIFESTYLE LTD	2020-06-16	None	GB	12674178	https://opencorporates.com/companies/gb/12674178	http://register.openownership.org/entities/5f1f11ec84281976229cd306	None	None	None	None
8	1294	5659990438031123930	AYAN INVESTMENTS LTD	2013-03-15	None	GB	08447018	https://opencorporates.com/companies/gb/08447018	http://register.openownership.org/entities/59b957da67e4ebf340e4bcdc	Private Limited Company	Active	MICRO ENTITY	64209 - Activities of other holding companies n.e.c.
9	6817	9362310756853578640	J & L SYSONBY HOLDINGS LIMITED	2016-09-05	None	GB	10358652	https://opencorporates.com/companies/gb/10358652	http://register.openownership.org/entities/59b9e40467e4ebf340201c0f	Private Limited Company	Active	TOTAL EXEMPTION FULL	47190 - Other retail sale in non-specialised stores

Last rows

	df_index	statementID	name	foundingDate	dissolutionDate	countryCode	companiesHouseID	openCorporatesID	openOwnershipRegisterID	CompanyCategory	CompanyStatus	Accounts_AccountCategory	SICCode_SicText_1
990	4054	4845625195067271126	INSPIRE FITNESS 121 LTD	2019-02-01	None	GB	11802688	https://opencorporates.com/companies/gb/11802688	http://register.openownership.org/entities/5c5bd9b29dfc3fae1825f457	Private Limited Company	Active	TOTAL EXEMPTION FULL	96040 - Physical well-being activities
991	5094	3309642346195000690	MONKEY GRINDER LIMITED	2017-06-01	None	GB	10797692	https://opencorporates.com/companies/gb/10797692	http://register.openownership.org/entities/59b9c79267e4ebf340b6bc16	Private Limited Company	Active - Proposal to Strike off	DORMANT	56302 - Public houses and bars
992	2351	6275264334036127378	ALL PAWS AND CLAWS DOG SUPPLIES LTD	2021-08-26	None	GB	13587509	https://opencorporates.com/companies/gb/13587509	http://register.openownership.org/entities/61532e8843b30a9a879722d9	Private Limited Company	Active	NO ACCOUNTS FILED	47760 - Retail sale of flowers, plants, seeds, fertilizers, pet animals and pet food in specialised stores
993	4097	13549231433332385833	SOUTHWELL HOMES LIMITED	2004-07-19	None	GB	05182817	https://opencorporates.com/companies/gb/05182817	http://register.openownership.org/entities/59b9250367e4ebf340fc27e6	Private Limited Company	Active	TOTAL EXEMPTION FULL	41201 - Construction of commercial buildings
994	4367	1044224546179366862	RAKSPRING & TRAFFIC JAM RECORDS LTD	2019-09-26	None	GB	12227934	https://opencorporates.com/companies/gb/12227934	http://register.openownership.org/entities/5da754c69dfc3fae1823a03a	Private Limited Company	Active	DORMANT	59200 - Sound recording and music publishing activities
995	1277	12513068543715449624	DIGITAL FASHION LTD	2021-08-26	None	GB	13587352	https://opencorporates.com/companies/gb/13587352	http://register.openownership.org/entities/61532e7b43b30a9a87970b69	Private Limited Company	Active	NO ACCOUNTS FILED	47410 - Retail sale of computers, peripheral units and software in specialised stores
996	2098	17967827072728966909	SMG INTERIORS LIMITED	2014-08-19	None	GB	09181419	https://opencorporates.com/companies/gb/09181419	http://register.openownership.org/entities/59b96f8e67e4ebf34056e34a	Private Limited Company	Active	MICRO ENTITY	43290 - Other construction installation
997	5903	4398747519184758591	JUNIPERUS VENTURES LIMITED	2019-08-22	2021-03-30	GB	12170017	https://opencorporates.com/companies/gb/12170017	http://register.openownership.org/entities/5d721e039dfc3fae18dbaf66	None	None	None	None
998	5882	18422145717058358860	JBCYBERPRODUCTS LTD	2022-04-01	None	GB	14018076	https://opencorporates.com/companies/gb/14018076	http://register.openownership.org/entities/6257428f0421b9f92d0fe9f6	Private Limited Company	Active	NO ACCOUNTS FILED	47910 - Retail sale via mail order houses or via Internet
999	2632	17955519609785945237	THE MARKETING HOUSE LTD	2022-01-25	None	GB	13870291	https://opencorporates.com/companies/gb/13870291	http://register.openownership.org/entities/6216c61add90051720175496	Private Limited Company	Active	NO ACCOUNTS FILED	70229 - Management consultancy activities other than financial management

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Final Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters